Overview
Brought to you by YData
Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 1060708 |
| Missing cells | 32061 |
| Missing cells (%) | 0.1% |
| Duplicate rows | 116213 |
| Duplicate rows (%) | 11.0% |
| Total size in memory | 595.3 MiB |
| Average record size in memory | 588.5 B |
Variable types
| Numeric | 13 |
|---|---|
| DateTime | 3 |
| Categorical | 2 |
| Text | 3 |
| Dataset has 116213 (11.0%) duplicate rows | Duplicates |
Breadth is highly overall correlated with Draught and 1 other fields | High correlation |
COG is highly overall correlated with TH | High correlation |
Draught is highly overall correlated with Breadth and 3 other fields | High correlation |
EndLatitude is highly overall correlated with EndLongitude and 6 other fields | High correlation |
EndLongitude is highly overall correlated with EndLatitude and 6 other fields | High correlation |
EndPort is highly overall correlated with Draught and 8 other fields | High correlation |
Latitude is highly overall correlated with EndLatitude and 6 other fields | High correlation |
Length is highly overall correlated with Breadth and 1 other fields | High correlation |
Longitude is highly overall correlated with EndLatitude and 6 other fields | High correlation |
StartLatitude is highly overall correlated with EndLatitude and 6 other fields | High correlation |
StartLongitude is highly overall correlated with EndLatitude and 6 other fields | High correlation |
StartPort is highly overall correlated with Draught and 8 other fields | High correlation |
TH is highly overall correlated with COG | High correlation |
shiptype is highly overall correlated with EndPort and 1 other fields | High correlation |
Draught has 16270 (1.5%) missing values | Missing |
Length has 10924 (1.0%) zeros | Zeros |
Breadth has 10924 (1.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-05-25 23:09:54.248823 |
|---|---|
| Analysis finished | 2025-05-25 23:10:43.866456 |
| Duration | 49.62 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
StartLatitude
Real number (ℝ)
High correlation
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.002772 |
| Minimum | 53.33 |
|---|---|
| Maximum | 54.54 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 53.33 |
|---|---|
| 5-th percentile | 53.52 |
| Q1 | 53.58 |
| median | 54.36 |
| Q3 | 54.36 |
| 95-th percentile | 54.36 |
| Maximum | 54.54 |
| Range | 1.21 |
| Interquartile range (IQR) | 0.78 |
Descriptive statistics
| Standard deviation | 0.39536968 |
|---|---|
| Coefficient of variation (CV) | 0.0073212849 |
| Kurtosis | -1.9299808 |
| Mean | 54.002772 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.2043408 |
| Sum | 57281172 |
| Variance | 0.15631718 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 54.36 | 571220 | |
| 53.58 | 222955 | 21.0% |
| 53.59 | 61008 | 5.8% |
| 53.53 | 45805 | 4.3% |
| 53.51 | 34010 | 3.2% |
| 53.57 | 29724 | 2.8% |
| 53.6 | 25943 | 2.4% |
| 53.52 | 17521 | 1.7% |
| 53.61 | 8363 | 0.8% |
| 53.55 | 5686 | 0.5% |
| Other values (18) | 38473 | 3.6% |
| Value | Count | Frequency (%) |
| 53.33 | 3169 | 0.3% |
| 53.34 | 2535 | 0.2% |
| 53.5 | 1285 | 0.1% |
| 53.51 | 34010 | |
| 53.52 | 17521 | 1.7% |
| 53.53 | 45805 | |
| 53.54 | 1289 | 0.1% |
| 53.55 | 5686 | 0.5% |
| 53.56 | 5654 | 0.5% |
| 53.57 | 29724 |
| Value | Count | Frequency (%) |
| 54.54 | 3672 | 0.3% |
| 54.49 | 552 | 0.1% |
| 54.37 | 1260 | 0.1% |
| 54.36 | 571220 | |
| 54.33 | 3168 | 0.3% |
| 54.31 | 1158 | 0.1% |
| 53.75 | 976 | 0.1% |
| 53.74 | 530 | < 0.1% |
| 53.67 | 4300 | 0.4% |
| 53.66 | 411 | < 0.1% |
StartLongitude
Real number (ℝ)
High correlation
| Distinct | 34 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.4050804 |
| Minimum | 8.14 |
|---|---|
| Maximum | 10.34 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 8.14 |
|---|---|
| 5-th percentile | 8.5 |
| Q1 | 8.52 |
| median | 10.14 |
| Q3 | 10.14 |
| 95-th percentile | 10.14 |
| Maximum | 10.34 |
| Range | 2.2 |
| Interquartile range (IQR) | 1.62 |
Descriptive statistics
| Standard deviation | 0.81150576 |
|---|---|
| Coefficient of variation (CV) | 0.086283767 |
| Kurtosis | -1.9401815 |
| Mean | 9.4050804 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.20234872 |
| Sum | 9976044.1 |
| Variance | 0.65854161 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=34)
| Value | Count | Frequency (%) |
| 10.14 | 543986 | |
| 8.52 | 194761 | 18.4% |
| 8.53 | 104786 | 9.9% |
| 8.57 | 60852 | 5.7% |
| 8.51 | 40838 | 3.9% |
| 10.13 | 24050 | 2.3% |
| 8.54 | 15232 | 1.4% |
| 8.5 | 12688 | 1.2% |
| 8.15 | 10967 | 1.0% |
| 8.49 | 9064 | 0.9% |
| Other values (24) | 43484 | 4.1% |
| Value | Count | Frequency (%) |
| 8.14 | 485 | < 0.1% |
| 8.15 | 10967 | |
| 8.16 | 1298 | 0.1% |
| 8.19 | 976 | 0.1% |
| 8.22 | 530 | < 0.1% |
| 8.36 | 2156 | 0.2% |
| 8.37 | 2144 | 0.2% |
| 8.38 | 411 | < 0.1% |
| 8.39 | 984 | 0.1% |
| 8.4 | 523 | < 0.1% |
| Value | Count | Frequency (%) |
| 10.34 | 552 | 0.1% |
| 10.29 | 3672 | 0.3% |
| 10.18 | 3188 | 0.3% |
| 10.17 | 2939 | 0.3% |
| 10.16 | 1489 | 0.1% |
| 10.15 | 1154 | 0.1% |
| 10.14 | 543986 | |
| 10.13 | 24050 | 2.3% |
| 8.57 | 60852 | 5.7% |
| 8.56 | 3146 | 0.3% |
StartTime
Date
| Distinct | 953 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.1 MiB |
| Minimum | 2016-01-13 06:03:00 |
|---|---|
| Maximum | 2017-05-26 19:44:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
EndLatitude
Real number (ℝ)
High correlation
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.045262 |
| Minimum | 53.47 |
|---|---|
| Maximum | 54.64 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 53.47 |
|---|---|
| 5-th percentile | 53.5 |
| Q1 | 53.53 |
| median | 54.38 |
| Q3 | 54.53 |
| 95-th percentile | 54.54 |
| Maximum | 54.64 |
| Range | 1.17 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.47881511 |
|---|---|
| Coefficient of variation (CV) | 0.0088595206 |
| Kurtosis | -1.9291169 |
| Mean | 54.045262 |
| Median Absolute Deviation (MAD) | 0.16 |
| Skewness | -0.15909692 |
| Sum | 57326241 |
| Variance | 0.22926391 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=29)
| Value | Count | Frequency (%) |
| 53.53 | 248414 | |
| 54.54 | 223218 | |
| 53.5 | 120692 | |
| 54.38 | 97636 | 9.2% |
| 54.52 | 56917 | 5.4% |
| 53.52 | 44887 | 4.2% |
| 54.53 | 44210 | 4.2% |
| 54.44 | 42625 | 4.0% |
| 53.54 | 37792 | 3.6% |
| 54.43 | 30822 | 2.9% |
| Other values (19) | 113495 |
| Value | Count | Frequency (%) |
| 53.47 | 1291 | 0.1% |
| 53.48 | 677 | 0.1% |
| 53.49 | 10546 | 1.0% |
| 53.5 | 120692 | |
| 53.51 | 10832 | 1.0% |
| 53.52 | 44887 | 4.2% |
| 53.53 | 248414 | |
| 53.54 | 37792 | 3.6% |
| 53.56 | 678 | 0.1% |
| 53.61 | 2018 | 0.2% |
| Value | Count | Frequency (%) |
| 54.64 | 1646 | 0.2% |
| 54.59 | 740 | 0.1% |
| 54.54 | 223218 | |
| 54.53 | 44210 | 4.2% |
| 54.52 | 56917 | 5.4% |
| 54.51 | 5176 | 0.5% |
| 54.5 | 522 | < 0.1% |
| 54.47 | 1282 | 0.1% |
| 54.46 | 7698 | 0.7% |
| 54.45 | 8806 | 0.8% |
EndLongitude
Real number (ℝ)
High correlation
| Distinct | 47 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.668992 |
| Minimum | 9.5 |
|---|---|
| Maximum | 18.92 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 9.5 |
|---|---|
| 5-th percentile | 9.9 |
| Q1 | 9.92 |
| median | 18.5 |
| Q3 | 18.6 |
| 95-th percentile | 18.71 |
| Maximum | 18.92 |
| Range | 9.42 |
| Interquartile range (IQR) | 8.68 |
Descriptive statistics
| Standard deviation | 4.3208528 |
|---|---|
| Coefficient of variation (CV) | 0.2945569 |
| Kurtosis | -1.9620247 |
| Mean | 14.668992 |
| Median Absolute Deviation (MAD) | 0.21 |
| Skewness | -0.19134138 |
| Sum | 15559517 |
| Variance | 18.669769 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=47)
| Value | Count | Frequency (%) |
| 9.91 | 125320 | |
| 18.51 | 120016 | 11.3% |
| 18.5 | 103202 | 9.7% |
| 9.93 | 88646 | 8.4% |
| 9.9 | 76211 | 7.2% |
| 9.95 | 72994 | 6.9% |
| 18.66 | 49594 | 4.7% |
| 18.65 | 49227 | 4.6% |
| 18.67 | 38212 | 3.6% |
| 18.71 | 35136 | 3.3% |
| Other values (37) | 302150 |
| Value | Count | Frequency (%) |
| 9.5 | 1190 | 0.1% |
| 9.51 | 661 | 0.1% |
| 9.54 | 1196 | 0.1% |
| 9.55 | 178 | < 0.1% |
| 9.56 | 644 | 0.1% |
| 9.73 | 678 | 0.1% |
| 9.82 | 27618 | 2.6% |
| 9.83 | 6963 | 0.7% |
| 9.88 | 1222 | 0.1% |
| 9.9 | 76211 |
| Value | Count | Frequency (%) |
| 18.92 | 1646 | 0.2% |
| 18.88 | 740 | 0.1% |
| 18.83 | 9886 | 0.9% |
| 18.82 | 18777 | |
| 18.81 | 4884 | 0.5% |
| 18.75 | 1501 | 0.1% |
| 18.72 | 3778 | 0.4% |
| 18.71 | 35136 | |
| 18.7 | 7901 | 0.7% |
| 18.68 | 3372 | 0.3% |
EndTime
Date
| Distinct | 943 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.1 MiB |
| Minimum | 2016-01-13 14:36:00 |
|---|---|
| Maximum | 2017-05-27 22:11:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
StartPort
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 64.9 MiB |
| KIEL | |
|---|---|
| BREMERHAVEN | |
| GDYNIA | 1 |
Length
| Max length | 11 |
|---|---|
| Median length | 4 |
| Mean length | 7.1655724 |
| Min length | 4 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | BREMERHAVEN |
|---|---|
| 2nd row | BREMERHAVEN |
| 3rd row | BREMERHAVEN |
| 4th row | BREMERHAVEN |
| 5th row | BREMERHAVEN |
Common Values
| Value | Count | Frequency (%) |
| KIEL | 581029 | |
| BREMERHAVEN | 479678 | |
| GDYNIA | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| kiel | 581029 | |
| bremerhaven | 479678 | |
| gdynia | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 2020063 | |
| R | 959356 | |
| I | 581030 | 7.6% |
| K | 581029 | 7.6% |
| L | 581029 | 7.6% |
| A | 479679 | 6.3% |
| N | 479679 | 6.3% |
| B | 479678 | 6.3% |
| H | 479678 | 6.3% |
| M | 479678 | 6.3% |
| Other values (4) | 479681 | 6.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7600580 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 2020063 | |
| R | 959356 | |
| I | 581030 | 7.6% |
| K | 581029 | 7.6% |
| L | 581029 | 7.6% |
| A | 479679 | 6.3% |
| N | 479679 | 6.3% |
| B | 479678 | 6.3% |
| H | 479678 | 6.3% |
| M | 479678 | 6.3% |
| Other values (4) | 479681 | 6.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7600580 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 2020063 | |
| R | 959356 | |
| I | 581030 | 7.6% |
| K | 581029 | 7.6% |
| L | 581029 | 7.6% |
| A | 479679 | 6.3% |
| N | 479679 | 6.3% |
| B | 479678 | 6.3% |
| H | 479678 | 6.3% |
| M | 479678 | 6.3% |
| Other values (4) | 479681 | 6.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7600580 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 2020063 | |
| R | 959356 | |
| I | 581030 | 7.6% |
| K | 581029 | 7.6% |
| L | 581029 | 7.6% |
| A | 479679 | 6.3% |
| N | 479679 | 6.3% |
| B | 479678 | 6.3% |
| H | 479678 | 6.3% |
| M | 479678 | 6.3% |
| Other values (4) | 479681 | 6.3% |
EndPort
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 64.2 MiB |
| GDYNIA | |
|---|---|
| HAMBURG | |
| 486589203 | 1 |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 6.4522272 |
| Min length | 6 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | HAMBURG |
|---|---|
| 2nd row | HAMBURG |
| 3rd row | HAMBURG |
| 4th row | HAMBURG |
| 5th row | HAMBURG |
Common Values
| Value | Count | Frequency (%) |
| GDYNIA | 581029 | |
| HAMBURG | 479678 | |
| 486589203 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| gdynia | 581029 | |
| hamburg | 479678 | |
| 486589203 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 1060707 | |
| A | 1060707 | |
| D | 581029 | |
| Y | 581029 | |
| N | 581029 | |
| I | 581029 | |
| H | 479678 | |
| M | 479678 | |
| B | 479678 | |
| U | 479678 | |
| Other values (9) | 479687 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6843929 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| G | 1060707 | |
| A | 1060707 | |
| D | 581029 | |
| Y | 581029 | |
| N | 581029 | |
| I | 581029 | |
| H | 479678 | |
| M | 479678 | |
| B | 479678 | |
| U | 479678 | |
| Other values (9) | 479687 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6843929 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| G | 1060707 | |
| A | 1060707 | |
| D | 581029 | |
| Y | 581029 | |
| N | 581029 | |
| I | 581029 | |
| H | 479678 | |
| M | 479678 | |
| B | 479678 | |
| U | 479678 | |
| Other values (9) | 479687 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6843929 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| G | 1060707 | |
| A | 1060707 | |
| D | 581029 | |
| Y | 581029 | |
| N | 581029 | |
| I | 581029 | |
| H | 479678 | |
| M | 479678 | |
| B | 479678 | |
| U | 479678 | |
| Other values (9) | 479687 |
ID
Text
| Distinct | 786068 |
|---|---|
| Distinct (%) | 74.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 66.8 MiB |
Length
| Max length | 18 |
|---|---|
| Median length | 9 |
| Mean length | 9.0851158 |
| Min length | 4 |
Unique
| Unique | 660326 ? |
|---|---|
| Unique (%) | 62.3% |
Sample
| 1st row | 43547405 |
|---|---|
| 2nd row | 43549625 |
| 3rd row | 43550197 |
| 4th row | 43551086 |
| 5th row | 43554910 |
| Value | Count | Frequency (%) |
| 381399218 | 18 | < 0.1% |
| 381401017 | 18 | < 0.1% |
| 381402959 | 18 | < 0.1% |
| 381406559 | 18 | < 0.1% |
| 381393152 | 18 | < 0.1% |
| 381405019 | 18 | < 0.1% |
| 381437846 | 18 | < 0.1% |
| 381365296 | 18 | < 0.1% |
| 381409375 | 18 | < 0.1% |
| 458461805 | 18 | < 0.1% |
| Other values (786059) | 1060529 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1230054 | |
| 4 | 1089345 | |
| 5 | 1031026 | |
| 2 | 1023910 | |
| 3 | 1012096 | |
| 8 | 859887 | |
| 0 | 857934 | |
| 7 | 854936 | |
| 6 | 844012 | |
| 9 | 833449 | |
| Other values (4) | 6 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9636655 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1230054 | |
| 4 | 1089345 | |
| 5 | 1031026 | |
| 2 | 1023910 | |
| 3 | 1012096 | |
| 8 | 859887 | |
| 0 | 857934 | |
| 7 | 854936 | |
| 6 | 844012 | |
| 9 | 833449 | |
| Other values (4) | 6 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9636655 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1230054 | |
| 4 | 1089345 | |
| 5 | 1031026 | |
| 2 | 1023910 | |
| 3 | 1012096 | |
| 8 | 859887 | |
| 0 | 857934 | |
| 7 | 854936 | |
| 6 | 844012 | |
| 9 | 833449 | |
| Other values (4) | 6 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9636655 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1230054 | |
| 4 | 1089345 | |
| 5 | 1031026 | |
| 2 | 1023910 | |
| 3 | 1012096 | |
| 8 | 859887 | |
| 0 | 857934 | |
| 7 | 854936 | |
| 6 | 844012 | |
| 9 | 833449 | |
| Other values (4) | 6 | < 0.1% |
time
Date
| Distinct | 414192 |
|---|---|
| Distinct (%) | 39.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 8.1 MiB |
| Minimum | 2016-01-13 07:03:00+01:00 |
|---|---|
| Maximum | 2017-05-28 00:11:00+02:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
shiptype
Real number (ℝ)
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 72.004988 |
| Minimum | 0 |
|---|---|
| Maximum | 155 |
| Zeros | 7224 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 70 |
| Q1 | 70 |
| median | 71 |
| Q3 | 71 |
| 95-th percentile | 81 |
| Maximum | 155 |
| Range | 155 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 7.036471 |
|---|---|
| Coefficient of variation (CV) | 0.097721994 |
| Kurtosis | 72.034492 |
| Mean | 72.004988 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -7.0217005 |
| Sum | 76376267 |
| Variance | 49.511924 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 71 | 456256 | |
| 70 | 355276 | |
| 79 | 142274 | 13.4% |
| 81 | 65116 | 6.1% |
| 72 | 13891 | 1.3% |
| 80 | 11569 | 1.1% |
| 0 | 7224 | 0.7% |
| 74 | 3745 | 0.4% |
| 73 | 3627 | 0.3% |
| 69 | 1144 | 0.1% |
| Other values (2) | 586 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 7224 | 0.7% |
| 69 | 1144 | 0.1% |
| 70 | 355276 | |
| 71 | 456256 | |
| 72 | 13891 | 1.3% |
| 73 | 3627 | 0.3% |
| 74 | 3745 | 0.4% |
| 79 | 142274 | 13.4% |
| 80 | 11569 | 1.1% |
| 81 | 65116 | 6.1% |
| Value | Count | Frequency (%) |
| 155 | 1 | < 0.1% |
| 89 | 585 | 0.1% |
| 81 | 65116 | 6.1% |
| 80 | 11569 | 1.1% |
| 79 | 142274 | 13.4% |
| 74 | 3745 | 0.4% |
| 73 | 3627 | 0.3% |
| 72 | 13891 | 1.3% |
| 71 | 456256 | |
| 70 | 355276 |
Length
Real number (ℝ)
High correlation Zeros
| Distinct | 108 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 125.19246 |
| Minimum | 0 |
|---|---|
| Maximum | 745 |
| Zeros | 10924 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 68 |
| Q1 | 88 |
| median | 134 |
| Q3 | 151 |
| 95-th percentile | 170 |
| Maximum | 745 |
| Range | 745 |
| Interquartile range (IQR) | 63 |
Descriptive statistics
| Standard deviation | 46.100907 |
|---|---|
| Coefficient of variation (CV) | 0.3682403 |
| Kurtosis | 19.6454 |
| Mean | 125.19246 |
| Median Absolute Deviation (MAD) | 32 |
| Skewness | 2.2124777 |
| Sum | 1.3279264 × 108 |
| Variance | 2125.2936 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 151 | 115425 | 10.9% |
| 134 | 82214 | 7.8% |
| 125 | 68105 | 6.4% |
| 88 | 63797 | 6.0% |
| 68 | 62288 | 5.9% |
| 155 | 59903 | 5.6% |
| 82 | 48473 | 4.6% |
| 168 | 41015 | 3.9% |
| 101 | 39221 | 3.7% |
| 79 | 34122 | 3.2% |
| Other values (98) | 446145 |
| Value | Count | Frequency (%) |
| 0 | 10924 | 1.0% |
| 25 | 1 | < 0.1% |
| 45 | 1760 | 0.2% |
| 64 | 250 | < 0.1% |
| 65 | 1362 | 0.1% |
| 66 | 1509 | 0.1% |
| 68 | 62288 | |
| 70 | 6114 | 0.6% |
| 74 | 9904 | 0.9% |
| 75 | 10082 | 1.0% |
| Value | Count | Frequency (%) |
| 745 | 73 | < 0.1% |
| 666 | 163 | < 0.1% |
| 665 | 1 | < 0.1% |
| 663 | 593 | 0.1% |
| 457 | 19 | < 0.1% |
| 399 | 1716 | |
| 397 | 1153 | |
| 396 | 660 | 0.1% |
| 377 | 13 | < 0.1% |
| 300 | 1142 |
Breadth
Real number (ℝ)
High correlation Zeros
| Distinct | 37 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.793313 |
| Minimum | 0 |
|---|---|
| Maximum | 60 |
| Zeros | 10924 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 13 |
| median | 22 |
| Q3 | 24 |
| 95-th percentile | 27 |
| Maximum | 60 |
| Range | 60 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 6.3733717 |
|---|---|
| Coefficient of variation (CV) | 0.32199621 |
| Kurtosis | 4.5083163 |
| Mean | 19.793313 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.5233135 |
| Sum | 20994925 |
| Variance | 40.619867 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=37)
| Value | Count | Frequency (%) |
| 22 | 156866 | |
| 12 | 141817 | |
| 23 | 141407 | |
| 24 | 112365 | |
| 13 | 96755 | |
| 18 | 70665 | |
| 25 | 68273 | |
| 26 | 50806 | 4.8% |
| 19 | 38464 | 3.6% |
| 11 | 35475 | 3.3% |
| Other values (27) | 147815 |
| Value | Count | Frequency (%) |
| 0 | 10924 | 1.0% |
| 8 | 1760 | 0.2% |
| 9 | 637 | 0.1% |
| 9.3 | 1 | < 0.1% |
| 10 | 3753 | 0.4% |
| 11 | 35475 | 3.3% |
| 12 | 141817 | |
| 13 | 96755 | |
| 14 | 13143 | 1.2% |
| 15 | 14038 | 1.3% |
| Value | Count | Frequency (%) |
| 60 | 1716 | |
| 59 | 660 | 0.1% |
| 56 | 1153 | 0.1% |
| 48 | 1142 | 0.1% |
| 45 | 85 | < 0.1% |
| 42 | 1071 | 0.1% |
| 40 | 3919 | |
| 36 | 652 | 0.1% |
| 35 | 564 | 0.1% |
| 33 | 681 | 0.1% |
Draught
Real number (ℝ)
High correlation Missing
| Distinct | 239 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 16270 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.3532147 |
| Minimum | 0 |
|---|---|
| Maximum | 54.61 |
| Zeros | 50 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.8 |
| Q1 | 4.3 |
| median | 6.99 |
| Q3 | 8.1 |
| 95-th percentile | 9.3 |
| Maximum | 54.61 |
| Range | 54.61 |
| Interquartile range (IQR) | 3.8 |
Descriptive statistics
| Standard deviation | 2.1822369 |
|---|---|
| Coefficient of variation (CV) | 0.34348546 |
| Kurtosis | -0.86733974 |
| Mean | 6.3532147 |
| Median Absolute Deviation (MAD) | 1.61 |
| Skewness | -0.23438602 |
| Sum | 6635538.9 |
| Variance | 4.7621577 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3.2 | 62267 | 5.9% |
| 2.8 | 56246 | 5.3% |
| 8.3 | 30569 | 2.9% |
| 7.9 | 21869 | 2.1% |
| 8.1 | 20690 | 2.0% |
| 7.7 | 20220 | 1.9% |
| 7.8 | 20045 | 1.9% |
| 8.4 | 19158 | 1.8% |
| 3.8 | 16693 | 1.6% |
| 8 | 14619 | 1.4% |
| Other values (229) | 762062 | |
| (Missing) | 16270 | 1.5% |
| Value | Count | Frequency (%) |
| 0 | 50 | < 0.1% |
| 0.1 | 637 | 0.1% |
| 1.93 | 1771 | 0.2% |
| 2.3 | 1612 | 0.2% |
| 2.4 | 3660 | 0.3% |
| 2.5 | 1373 | 0.1% |
| 2.6 | 7279 | 0.7% |
| 2.63 | 41 | < 0.1% |
| 2.7 | 1783 | 0.2% |
| 2.8 | 56246 |
| Value | Count | Frequency (%) |
| 54.61 | 1 | < 0.1% |
| 14 | 15 | < 0.1% |
| 13.23 | 544 | |
| 11.7 | 645 | |
| 11.54 | 1071 | |
| 11.45 | 551 | |
| 11.4 | 1223 | |
| 11.24 | 691 | |
| 11.1 | 627 | |
| 11 | 368 | < 0.1% |
Latitude
Real number (ℝ)
High correlation
| Distinct | 274 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.254708 |
| Minimum | 14.63 |
|---|---|
| Maximum | 56.34 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 14.63 |
|---|---|
| 5-th percentile | 53.56 |
| Q1 | 53.84 |
| median | 54.42 |
| Q3 | 54.64 |
| 95-th percentile | 54.89 |
| Maximum | 56.34 |
| Range | 41.71 |
| Interquartile range (IQR) | 0.8 |
Descriptive statistics
| Standard deviation | 0.4627239 |
|---|---|
| Coefficient of variation (CV) | 0.0085287327 |
| Kurtosis | 49.525461 |
| Mean | 54.254708 |
| Median Absolute Deviation (MAD) | 0.44 |
| Skewness | -0.6150148 |
| Sum | 57548403 |
| Variance | 0.21411341 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 53.87 | 36524 | 3.4% |
| 53.84 | 25419 | 2.4% |
| 54.53 | 24948 | 2.4% |
| 53.98 | 24948 | 2.4% |
| 54.41 | 21658 | 2.0% |
| 53.54 | 21377 | 2.0% |
| 53.86 | 21117 | 2.0% |
| 53.85 | 20259 | 1.9% |
| 53.83 | 20080 | 1.9% |
| 53.97 | 19608 | 1.8% |
| Other values (264) | 824770 |
| Value | Count | Frequency (%) |
| 14.63 | 1 | < 0.1% |
| 53.33 | 13 | < 0.1% |
| 53.34 | 40 | |
| 53.35 | 29 | |
| 53.36 | 26 | |
| 53.37 | 25 | |
| 53.38 | 27 | |
| 53.39 | 26 | |
| 53.4 | 23 | |
| 53.41 | 24 |
| Value | Count | Frequency (%) |
| 56.34 | 2 | < 0.1% |
| 56.33 | 4 | < 0.1% |
| 56.32 | 4 | < 0.1% |
| 56.31 | 3 | < 0.1% |
| 56.3 | 3 | < 0.1% |
| 56.29 | 12 | |
| 56.28 | 8 | |
| 56.27 | 5 | |
| 56.26 | 5 | |
| 56.25 | 6 |
Longitude
Real number (ℝ)
High correlation
| Distinct | 1285 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.79557 |
| Minimum | 2.32 |
|---|---|
| Maximum | 20.66 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 2.32 |
|---|---|
| 5-th percentile | 8.07 |
| Q1 | 8.84 |
| median | 10.63 |
| Q3 | 13.91 |
| 95-th percentile | 18.78 |
| Maximum | 20.66 |
| Range | 18.34 |
| Interquartile range (IQR) | 5.07 |
Descriptive statistics
| Standard deviation | 3.4893558 |
|---|---|
| Coefficient of variation (CV) | 0.29581916 |
| Kurtosis | -0.52728493 |
| Mean | 11.79557 |
| Median Absolute Deviation (MAD) | 2.16 |
| Skewness | 0.83164662 |
| Sum | 12511656 |
| Variance | 12.175604 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9.51 | 5970 | 0.6% |
| 8.52 | 5919 | 0.6% |
| 8.12 | 5858 | 0.6% |
| 8.11 | 5439 | 0.5% |
| 9.93 | 5159 | 0.5% |
| 9.9 | 5087 | 0.5% |
| 9.5 | 5032 | 0.5% |
| 8.51 | 4573 | 0.4% |
| 9.39 | 4068 | 0.4% |
| 9.38 | 4061 | 0.4% |
| Other values (1275) | 1009542 |
| Value | Count | Frequency (%) |
| 2.32 | 1 | < 0.1% |
| 7.71 | 2 | < 0.1% |
| 7.72 | 45 | |
| 7.73 | 102 | |
| 7.74 | 99 | |
| 7.75 | 108 | |
| 7.76 | 83 | |
| 7.77 | 83 | |
| 7.78 | 81 | |
| 7.79 | 78 |
| Value | Count | Frequency (%) |
| 20.66 | 1 | < 0.1% |
| 20.65 | 3 | |
| 20.64 | 2 | < 0.1% |
| 20.63 | 2 | < 0.1% |
| 20.62 | 6 | |
| 20.61 | 6 | |
| 20.6 | 4 | |
| 20.59 | 6 | |
| 20.58 | 6 | |
| 20.57 | 6 |
SOG
Real number (ℝ)
| Distinct | 228 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.052629 |
| Minimum | 0.2 |
|---|---|
| Maximum | 80.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 0.2 |
|---|---|
| 5-th percentile | 6.6 |
| Q1 | 9.9 |
| median | 12 |
| Q3 | 14.5 |
| 95-th percentile | 17.4 |
| Maximum | 80.7 |
| Range | 80.5 |
| Interquartile range (IQR) | 4.6 |
Descriptive statistics
| Standard deviation | 3.4921684 |
|---|---|
| Coefficient of variation (CV) | 0.2897433 |
| Kurtosis | 1.0226024 |
| Mean | 12.052629 |
| Median Absolute Deviation (MAD) | 2.3 |
| Skewness | -0.44726681 |
| Sum | 12784320 |
| Variance | 12.19524 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10.5 | 14605 | 1.4% |
| 10.4 | 14338 | 1.4% |
| 10.7 | 14081 | 1.3% |
| 10.6 | 14073 | 1.3% |
| 11.7 | 13702 | 1.3% |
| 10.3 | 13450 | 1.3% |
| 11.6 | 13441 | 1.3% |
| 11 | 13198 | 1.2% |
| 10.9 | 12878 | 1.2% |
| 11.4 | 12670 | 1.2% |
| Other values (218) | 924272 |
| Value | Count | Frequency (%) |
| 0.2 | 443 | < 0.1% |
| 0.3 | 1912 | |
| 0.4 | 1615 | |
| 0.5 | 1232 | |
| 0.6 | 1093 | |
| 0.7 | 967 | |
| 0.8 | 1095 | |
| 0.9 | 1013 | |
| 1 | 915 | |
| 1.1 | 874 |
| Value | Count | Frequency (%) |
| 80.7 | 1 | < 0.1% |
| 73.6 | 2 | < 0.1% |
| 51.2 | 1 | < 0.1% |
| 22.6 | 1 | < 0.1% |
| 22.5 | 1 | < 0.1% |
| 22.4 | 2 | < 0.1% |
| 22.3 | 1 | < 0.1% |
| 22.2 | 4 | |
| 22.1 | 4 | |
| 22 | 6 |
COG
Real number (ℝ)
High correlation
| Distinct | 3602 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 126.98212 |
| Minimum | 0 |
|---|---|
| Maximum | 378 |
| Zeros | 210 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 45.9 |
| Q1 | 82 |
| median | 100 |
| Q3 | 136.3 |
| 95-th percentile | 314.9 |
| Maximum | 378 |
| Range | 378 |
| Interquartile range (IQR) | 54.3 |
Descriptive statistics
| Standard deviation | 77.95504 |
|---|---|
| Coefficient of variation (CV) | 0.61390564 |
| Kurtosis | 1.1463034 |
| Mean | 126.98212 |
| Median Absolute Deviation (MAD) | 22.7 |
| Skewness | 1.4540593 |
| Sum | 1.3469095 × 108 |
| Variance | 6076.9882 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 90 | 8874 | 0.8% |
| 81 | 8420 | 0.8% |
| 82 | 7569 | 0.7% |
| 89 | 6461 | 0.6% |
| 86 | 6142 | 0.6% |
| 100 | 6036 | 0.6% |
| 85 | 5864 | 0.6% |
| 88 | 5757 | 0.5% |
| 83 | 5702 | 0.5% |
| 87 | 5569 | 0.5% |
| Other values (3592) | 994314 |
| Value | Count | Frequency (%) |
| 0 | 210 | < 0.1% |
| 0.1 | 580 | |
| 0.2 | 32 | < 0.1% |
| 0.3 | 26 | < 0.1% |
| 0.4 | 19 | < 0.1% |
| 0.5 | 37 | < 0.1% |
| 0.6 | 37 | < 0.1% |
| 0.7 | 35 | < 0.1% |
| 0.8 | 37 | < 0.1% |
| 0.9 | 60 | < 0.1% |
| Value | Count | Frequency (%) |
| 378 | 1 | < 0.1% |
| 360 | 12 | < 0.1% |
| 359.9 | 69 | |
| 359.8 | 41 | |
| 359.7 | 18 | < 0.1% |
| 359.6 | 30 | |
| 359.5 | 34 | |
| 359.4 | 24 | < 0.1% |
| 359.3 | 41 | |
| 359.2 | 22 | < 0.1% |
TH
Real number (ℝ)
High correlation
| Distinct | 361 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 131.96792 |
| Minimum | 0 |
|---|---|
| Maximum | 511 |
| Zeros | 623 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 47 |
| Q1 | 82 |
| median | 100 |
| Q3 | 140 |
| 95-th percentile | 320 |
| Maximum | 511 |
| Range | 511 |
| Interquartile range (IQR) | 58 |
Descriptive statistics
| Standard deviation | 88.949001 |
|---|---|
| Coefficient of variation (CV) | 0.67401988 |
| Kurtosis | 3.3333632 |
| Mean | 131.96792 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | 1.8210265 |
| Sum | 1.399793 × 108 |
| Variance | 7911.9248 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 82 | 25863 | 2.4% |
| 81 | 24895 | 2.3% |
| 90 | 23223 | 2.2% |
| 83 | 23083 | 2.2% |
| 85 | 20672 | 1.9% |
| 84 | 20368 | 1.9% |
| 89 | 18944 | 1.8% |
| 88 | 17458 | 1.6% |
| 86 | 17427 | 1.6% |
| 80 | 17292 | 1.6% |
| Other values (351) | 851482 |
| Value | Count | Frequency (%) |
| 0 | 623 | |
| 1 | 556 | |
| 2 | 479 | |
| 3 | 531 | |
| 4 | 319 | |
| 5 | 328 | |
| 6 | 282 | |
| 7 | 330 | |
| 8 | 304 | |
| 9 | 229 | < 0.1% |
| Value | Count | Frequency (%) |
| 511 | 12985 | |
| 359 | 515 | < 0.1% |
| 358 | 617 | 0.1% |
| 357 | 398 | < 0.1% |
| 356 | 506 | < 0.1% |
| 355 | 594 | 0.1% |
| 354 | 524 | < 0.1% |
| 353 | 331 | < 0.1% |
| 352 | 312 | < 0.1% |
| 351 | 259 | < 0.1% |
Destination
Text
| Distinct | 140 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 5898 |
| Missing (%) | 0.6% |
| Memory size | 64.9 MiB |
Length
| Max length | 21 |
|---|---|
| Median length | 20 |
| Mean length | 7.3506698 |
| Min length | 2 |
Unique
| Unique | 10 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | HAMBURG |
|---|---|
| 2nd row | HAMBURG |
| 3rd row | HAMBURG |
| 4th row | HAMBURG |
| 5th row | HAMBURG |
| Value | Count | Frequency (%) |
| hamburg | 272461 | |
| gdynia | 222144 | |
| gdansk | 159967 | |
| deham | 103184 | 9.8% |
| gdynia.via.nok | 35601 | 3.4% |
| de.ham | 34098 | 3.2% |
| plgdn | 29926 | 2.8% |
| finkenwerder | 27420 | 2.6% |
| gdansk.via.nok | 25973 | 2.5% |
| debrv.>.deham | 21493 | 2.0% |
| Other values (120) | 122543 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1077309 | |
| G | 826091 | |
| D | 808213 | |
| N | 683408 | 8.8% |
| H | 460718 | 5.9% |
| M | 451050 | 5.8% |
| I | 427304 | 5.5% |
| R | 368528 | 4.8% |
| K | 350212 | 4.5% |
| E | 327581 | 4.2% |
| Other values (36) | 1973146 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7753560 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 1077309 | |
| G | 826091 | |
| D | 808213 | |
| N | 683408 | 8.8% |
| H | 460718 | 5.9% |
| M | 451050 | 5.8% |
| I | 427304 | 5.5% |
| R | 368528 | 4.8% |
| K | 350212 | 4.5% |
| E | 327581 | 4.2% |
| Other values (36) | 1973146 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7753560 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 1077309 | |
| G | 826091 | |
| D | 808213 | |
| N | 683408 | 8.8% |
| H | 460718 | 5.9% |
| M | 451050 | 5.8% |
| I | 427304 | 5.5% |
| R | 368528 | 4.8% |
| K | 350212 | 4.5% |
| E | 327581 | 4.2% |
| Other values (36) | 1973146 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7753560 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 1077309 | |
| G | 826091 | |
| D | 808213 | |
| N | 683408 | 8.8% |
| H | 460718 | 5.9% |
| M | 451050 | 5.8% |
| I | 427304 | 5.5% |
| R | 368528 | 4.8% |
| K | 350212 | 4.5% |
| E | 327581 | 4.2% |
| Other values (36) | 1973146 |
AisSourcen
Text
| Distinct | 223 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9891 |
| Missing (%) | 0.9% |
| Memory size | 69.4 MiB |
Length
| Max length | 31 |
|---|---|
| Median length | 28 |
| Mean length | 11.994006 |
| Min length | 2 |
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | DAIS1.81b.90b.71.71a |
|---|---|
| 2nd row | DAIS1.81b.90b.71.71a |
| 3rd row | DAIS1.81b.90b.71.71a |
| 4th row | DAIS1.81b.90b.71.71a |
| 5th row | DAIS1.81b.90b.71.71a |
| Value | Count | Frequency (%) |
| h7001 | 158252 | |
| 51.71a.h7001.81b | 99047 | 9.4% |
| 71a.h7001.81b | 85871 | 8.2% |
| 71.51.71a.h7001.81b | 67024 | 6.4% |
| 71.71a.h7001.81b | 61410 | 5.8% |
| 71a.h7001 | 48129 | 4.6% |
| 71a.h7001.67b | 42889 | 4.1% |
| 71.71a.h7001 | 40625 | 3.9% |
| 71.71a.h7001.67b | 33854 | 3.2% |
| 71.71a.67b | 33694 | 3.2% |
| Other values (213) | 380022 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2823931 | |
| 7 | 2263856 | |
| . | 2084889 | |
| 0 | 1722274 | |
| H | 838755 | 6.7% |
| a | 829978 | 6.6% |
| b | 682836 | 5.4% |
| 8 | 439536 | 3.5% |
| 5 | 287020 | 2.3% |
| 6 | 226348 | 1.8% |
| Other values (20) | 404082 | 3.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12603505 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2823931 | |
| 7 | 2263856 | |
| . | 2084889 | |
| 0 | 1722274 | |
| H | 838755 | 6.7% |
| a | 829978 | 6.6% |
| b | 682836 | 5.4% |
| 8 | 439536 | 3.5% |
| 5 | 287020 | 2.3% |
| 6 | 226348 | 1.8% |
| Other values (20) | 404082 | 3.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12603505 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2823931 | |
| 7 | 2263856 | |
| . | 2084889 | |
| 0 | 1722274 | |
| H | 838755 | 6.7% |
| a | 829978 | 6.6% |
| b | 682836 | 5.4% |
| 8 | 439536 | 3.5% |
| 5 | 287020 | 2.3% |
| 6 | 226348 | 1.8% |
| Other values (20) | 404082 | 3.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12603505 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2823931 | |
| 7 | 2263856 | |
| . | 2084889 | |
| 0 | 1722274 | |
| H | 838755 | 6.7% |
| a | 829978 | 6.6% |
| b | 682836 | 5.4% |
| 8 | 439536 | 3.5% |
| 5 | 287020 | 2.3% |
| 6 | 226348 | 1.8% |
| Other values (20) | 404082 | 3.2% |
Interactions
Correlations
| Breadth | COG | Draught | EndLatitude | EndLongitude | EndPort | Latitude | Length | Longitude | SOG | StartLatitude | StartLongitude | StartPort | TH | shiptype | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Breadth | 1.000 | 0.013 | 0.889 | 0.114 | -0.214 | 0.171 | -0.044 | 0.942 | -0.050 | 0.410 | 0.044 | -0.154 | 0.171 | 0.002 | 0.268 |
| COG | 0.013 | 1.000 | -0.020 | -0.299 | -0.298 | 0.311 | -0.370 | -0.026 | -0.154 | 0.010 | -0.328 | -0.311 | 0.311 | 0.941 | 0.046 |
| Draught | 0.889 | -0.020 | 1.000 | 0.165 | -0.110 | 0.711 | 0.040 | 0.900 | 0.031 | 0.413 | 0.155 | -0.068 | 0.711 | -0.024 | 0.274 |
| EndLatitude | 0.114 | -0.299 | 0.165 | 1.000 | 0.560 | 0.707 | 0.764 | 0.189 | 0.751 | -0.045 | 0.821 | 0.796 | 0.707 | -0.290 | -0.136 |
| EndLongitude | -0.214 | -0.298 | -0.110 | 0.560 | 1.000 | 1.000 | 0.737 | -0.103 | 0.747 | -0.263 | 0.804 | 0.833 | 1.000 | -0.273 | -0.017 |
| EndPort | 0.171 | 0.311 | 0.711 | 0.707 | 1.000 | 1.000 | 1.000 | 0.184 | 0.650 | 0.411 | 0.707 | 0.707 | 1.000 | 0.397 | 0.709 |
| Latitude | -0.044 | -0.370 | 0.040 | 0.764 | 0.737 | 1.000 | 1.000 | 0.049 | 0.781 | -0.054 | 0.814 | 0.801 | 1.000 | -0.348 | -0.096 |
| Length | 0.942 | -0.026 | 0.900 | 0.189 | -0.103 | 0.184 | 0.049 | 1.000 | 0.046 | 0.397 | 0.181 | -0.072 | 0.184 | -0.033 | 0.223 |
| Longitude | -0.050 | -0.154 | 0.031 | 0.751 | 0.747 | 0.650 | 0.781 | 0.046 | 1.000 | -0.223 | 0.815 | 0.802 | 0.650 | -0.141 | -0.099 |
| SOG | 0.410 | 0.010 | 0.413 | -0.045 | -0.263 | 0.411 | -0.054 | 0.397 | -0.223 | 1.000 | -0.115 | -0.205 | 0.411 | -0.012 | 0.163 |
| StartLatitude | 0.044 | -0.328 | 0.155 | 0.821 | 0.804 | 0.707 | 0.814 | 0.181 | 0.815 | -0.115 | 1.000 | 0.812 | 0.707 | -0.309 | -0.115 |
| StartLongitude | -0.154 | -0.311 | -0.068 | 0.796 | 0.833 | 0.707 | 0.801 | -0.072 | 0.802 | -0.205 | 0.812 | 1.000 | 0.707 | -0.292 | -0.074 |
| StartPort | 0.171 | 0.311 | 0.711 | 0.707 | 1.000 | 1.000 | 1.000 | 0.184 | 0.650 | 0.411 | 0.707 | 0.707 | 1.000 | 0.397 | 0.709 |
| TH | 0.002 | 0.941 | -0.024 | -0.290 | -0.273 | 0.397 | -0.348 | -0.033 | -0.141 | -0.012 | -0.309 | -0.292 | 0.397 | 1.000 | 0.046 |
| shiptype | 0.268 | 0.046 | 0.274 | -0.136 | -0.017 | 0.709 | -0.096 | 0.223 | -0.099 | 0.163 | -0.115 | -0.074 | 0.709 | 0.046 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| StartLatitude | StartLongitude | StartTime | EndLatitude | EndLongitude | EndTime | StartPort | EndPort | ID | time | shiptype | Length | Breadth | Draught | Latitude | Longitude | SOG | COG | TH | Destination | AisSourcen | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 53.57 | 8.53 | '2016-01-24 08:06' | 53.53 | 9.9 | '2016-01-24 16:44' | BREMERHAVEN | HAMBURG | 43547405 | 2016-01-24 09:07:00+01:00 | 71 | 277 | 42.0 | 11.54 | 53.57 | 8.53 | 0.7 | 331.2 | 143.0 | HAMBURG | DAIS1.81b.90b.71.71a |
| 1 | 53.57 | 8.53 | '2016-01-24 08:06' | 53.53 | 9.9 | '2016-01-24 16:44' | BREMERHAVEN | HAMBURG | 43549625 | 2016-01-24 09:10:00+01:00 | 71 | 277 | 42.0 | 11.54 | 53.57 | 8.53 | 1.6 | 315.3 | 117.0 | HAMBURG | DAIS1.81b.90b.71.71a |
| 2 | 53.57 | 8.53 | '2016-01-24 08:06' | 53.53 | 9.9 | '2016-01-24 16:44' | BREMERHAVEN | HAMBURG | 43550197 | 2016-01-24 09:10:00+01:00 | 71 | 277 | 42.0 | 11.54 | 53.57 | 8.53 | 2.8 | 322.6 | 100.0 | HAMBURG | DAIS1.81b.90b.71.71a |
| 3 | 53.57 | 8.53 | '2016-01-24 08:06' | 53.53 | 9.9 | '2016-01-24 16:44' | BREMERHAVEN | HAMBURG | 43551086 | 2016-01-24 09:12:00+01:00 | 71 | 277 | 42.0 | 11.54 | 53.57 | 8.53 | 2.8 | 286.3 | 74.0 | HAMBURG | DAIS1.81b.90b.71.71a |
| 4 | 53.57 | 8.53 | '2016-01-24 08:06' | 53.53 | 9.9 | '2016-01-24 16:44' | BREMERHAVEN | HAMBURG | 43554910 | 2016-01-24 09:16:00+01:00 | 71 | 277 | 42.0 | 11.54 | 53.57 | 8.53 | 4.3 | 333.1 | 333.0 | HAMBURG | DAIS1.81b.90b.71.71a |
| 5 | 53.57 | 8.53 | '2016-01-24 08:06' | 53.53 | 9.9 | '2016-01-24 16:44' | BREMERHAVEN | HAMBURG | 43555883 | 2016-01-24 09:17:00+01:00 | 71 | 277 | 42.0 | 11.54 | 53.57 | 8.53 | 5.2 | 334.0 | 333.0 | HAMBURG | 51.DAIS1.81b.90b.71.71a |
| 6 | 53.57 | 8.53 | '2016-01-24 08:06' | 53.53 | 9.9 | '2016-01-24 16:44' | BREMERHAVEN | HAMBURG | 43556501 | 2016-01-24 09:18:00+01:00 | 71 | 277 | 42.0 | 11.54 | 53.57 | 8.53 | 5.7 | 333.0 | 333.0 | HAMBURG | 51.DAIS1.81b.90b.71.71a |
| 7 | 53.57 | 8.53 | '2016-01-24 08:06' | 53.53 | 9.9 | '2016-01-24 16:44' | BREMERHAVEN | HAMBURG | 43557132 | 2016-01-24 09:19:00+01:00 | 71 | 277 | 42.0 | 11.54 | 53.57 | 8.52 | 6.3 | 333.0 | 333.0 | HAMBURG | 51.DAIS1.81b.90b.71.71a |
| 8 | 53.57 | 8.53 | '2016-01-24 08:06' | 53.53 | 9.9 | '2016-01-24 16:44' | BREMERHAVEN | HAMBURG | 43557827 | 2016-01-24 09:20:00+01:00 | 71 | 277 | 42.0 | 11.54 | 53.58 | 8.52 | 6.8 | 333.0 | 333.0 | HAMBURG | 51.DAIS1.81b.90b.71.71a |
| 9 | 53.57 | 8.53 | '2016-01-24 08:06' | 53.53 | 9.9 | '2016-01-24 16:44' | BREMERHAVEN | HAMBURG | 43559240 | 2016-01-24 09:21:00+01:00 | 71 | 277 | 42.0 | 11.54 | 53.58 | 8.52 | 7.1 | 332.1 | 333.0 | HAMBURG | 51.DAIS1.81b.90b.71.71a |
| StartLatitude | StartLongitude | StartTime | EndLatitude | EndLongitude | EndTime | StartPort | EndPort | ID | time | shiptype | Length | Breadth | Draught | Latitude | Longitude | SOG | COG | TH | Destination | AisSourcen | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1060698 | 54.36 | 10.14 | '2017-04-03 07:54' | 54.38 | 18.66 | '2017-04-04 15:28' | KIEL | GDYNIA | 1617125703 | 2017-04-04 16:02:00+02:00 | 70 | 89 | 13.0 | 4.0 | 54.50 | 18.74 | 7.2 | 222.0 | 215.0 | GDANSK | H7001 |
| 1060699 | 54.36 | 10.14 | '2017-04-03 07:54' | 54.38 | 18.66 | '2017-04-04 15:28' | KIEL | GDYNIA | 1617122777 | 2017-04-04 16:01:00+02:00 | 70 | 89 | 13.0 | 4.0 | 54.50 | 18.74 | 7.2 | 221.6 | 215.0 | GDANSK | H7001 |
| 1060700 | 54.36 | 10.14 | '2017-04-03 07:54' | 54.38 | 18.66 | '2017-04-04 15:28' | KIEL | GDYNIA | 1617119896 | 2017-04-04 16:00:00+02:00 | 70 | 89 | 13.0 | 4.0 | 54.50 | 18.74 | 7.2 | 221.5 | 215.0 | GDANSK | H7001 |
| 1060701 | 54.36 | 10.14 | '2017-04-03 07:54' | 54.38 | 18.66 | '2017-04-04 15:28' | KIEL | GDYNIA | 1617116966 | 2017-04-04 15:59:00+02:00 | 70 | 89 | 13.0 | 4.0 | 54.50 | 18.75 | 7.2 | 221.2 | 215.0 | GDANSK | H7001 |
| 1060702 | 54.36 | 10.14 | '2017-04-03 07:54' | 54.38 | 18.66 | '2017-04-04 15:28' | KIEL | GDYNIA | 1617114075 | 2017-04-04 15:58:00+02:00 | 70 | 89 | 13.0 | 4.0 | 54.50 | 18.75 | 7.2 | 220.8 | 215.0 | GDANSK | H7001 |
| 1060703 | 54.36 | 10.14 | '2017-04-03 07:54' | 54.38 | 18.66 | '2017-04-04 15:28' | KIEL | GDYNIA | 1617111140 | 2017-04-04 15:57:00+02:00 | 70 | 89 | 13.0 | 4.0 | 54.51 | 18.75 | 7.2 | 221.0 | 215.0 | GDANSK | H7001 |
| 1060704 | 54.36 | 10.14 | '2017-04-03 07:54' | 54.38 | 18.66 | '2017-04-04 15:28' | KIEL | GDYNIA | 1617108202 | 2017-04-04 15:56:00+02:00 | 70 | 89 | 13.0 | 4.0 | 54.51 | 18.75 | 7.2 | 221.9 | 215.0 | GDANSK | H7001 |
| 1060705 | 54.36 | 10.14 | '2017-04-03 07:54' | 54.38 | 18.66 | '2017-04-04 15:28' | KIEL | GDYNIA | 1617105212 | 2017-04-04 15:55:00+02:00 | 70 | 89 | 13.0 | 4.0 | 54.51 | 18.75 | 7.2 | 222.1 | 215.0 | GDANSK | H7001 |
| 1060706 | 54.36 | 10.14 | '2017-04-03 07:54' | 54.38 | 18.66 | '2017-04-04 15:28' | KIEL | GDYNIA | 1617102302 | 2017-04-04 15:54:00+02:00 | 70 | 89 | 13.0 | 4.0 | 54.51 | 18.76 | 7.2 | 221.2 | 215.0 | GDANSK | H7001 |
| 1060707 | 54.36 | 10.14 | '2017-04-03 07:54' | 54.38 | 18.66 | '2017-04-04 15:28' | KIEL | GDYNIA | 1617099310 | 2017-04-04 15:53:00+02:00 | 70 | 89 | 13.0 | 4.0 | 54.51 | 18.76 | 7.2 | 221.0 | 214.0 | GDANSK | H7001 |
Duplicate rows
Most frequently occurring
| StartLatitude | StartLongitude | StartTime | EndLatitude | EndLongitude | EndTime | StartPort | EndPort | ID | time | shiptype | Length | Breadth | Draught | Latitude | Longitude | SOG | COG | TH | Destination | AisSourcen | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1884 | 53.52 | 8.57 | '2016-07-18 15:49' | 53.5 | 9.95 | '2016-07-19 01:54' | BREMERHAVEN | HAMBURG | 381008828 | 2016-07-18 17:49:00+02:00 | 81 | 68 | 12.0 | 3.2 | 53.52 | 8.57 | 2.1 | 346.0 | 158.0 | HAMBURG | 71a.H7001.90b | 18 |
| 1885 | 53.52 | 8.57 | '2016-07-18 15:49' | 53.5 | 9.95 | '2016-07-19 01:54' | BREMERHAVEN | HAMBURG | 381010264 | 2016-07-18 17:50:00+02:00 | 81 | 68 | 12.0 | 3.2 | 53.52 | 8.57 | 2.3 | 17.6 | 201.0 | HAMBURG | 71a.H7001.90b | 18 |
| 1886 | 53.52 | 8.57 | '2016-07-18 15:49' | 53.5 | 9.95 | '2016-07-19 01:54' | BREMERHAVEN | HAMBURG | 381012557 | 2016-07-18 17:51:00+02:00 | 81 | 68 | 12.0 | 3.2 | 53.52 | 8.57 | 1.9 | 42.5 | 217.0 | HAMBURG | 71a.H7001.90b | 18 |
| 1887 | 53.52 | 8.57 | '2016-07-18 15:49' | 53.5 | 9.95 | '2016-07-19 01:54' | BREMERHAVEN | HAMBURG | 381014058 | 2016-07-18 17:52:00+02:00 | 81 | 68 | 12.0 | 3.2 | 53.52 | 8.57 | 0.4 | 37.6 | 223.0 | HAMBURG | 71a.H7001.90b | 18 |
| 1888 | 53.52 | 8.57 | '2016-07-18 15:49' | 53.5 | 9.95 | '2016-07-19 01:54' | BREMERHAVEN | HAMBURG | 381016256 | 2016-07-18 17:53:00+02:00 | 81 | 68 | 12.0 | 3.2 | 53.52 | 8.57 | 1.3 | 246.2 | 306.0 | HAMBURG | 71a.H7001.90b | 18 |
| 1889 | 53.52 | 8.57 | '2016-07-18 15:49' | 53.5 | 9.95 | '2016-07-19 01:54' | BREMERHAVEN | HAMBURG | 381018479 | 2016-07-18 17:54:00+02:00 | 81 | 68 | 12.0 | 3.2 | 53.52 | 8.57 | 0.9 | 355.2 | 11.0 | HAMBURG | 71a.H7001.90b | 18 |
| 1890 | 53.52 | 8.57 | '2016-07-18 15:49' | 53.5 | 9.95 | '2016-07-19 01:54' | BREMERHAVEN | HAMBURG | 381020602 | 2016-07-18 17:55:00+02:00 | 81 | 68 | 12.0 | 3.2 | 53.52 | 8.57 | 0.6 | 0.1 | 13.0 | HAMBURG | 71a.H7001.90b | 18 |
| 1891 | 53.52 | 8.57 | '2016-07-18 15:49' | 53.5 | 9.95 | '2016-07-19 01:54' | BREMERHAVEN | HAMBURG | 381022500 | 2016-07-18 17:56:00+02:00 | 81 | 68 | 12.0 | 3.2 | 53.52 | 8.57 | 0.4 | 0.1 | 15.0 | HAMBURG | 71a.H7001.90b | 18 |
| 1892 | 53.52 | 8.57 | '2016-07-18 15:49' | 53.5 | 9.95 | '2016-07-19 01:54' | BREMERHAVEN | HAMBURG | 381024670 | 2016-07-18 17:57:00+02:00 | 81 | 68 | 12.0 | 3.2 | 53.52 | 8.57 | 0.4 | 0.1 | 17.0 | HAMBURG | 71a.H7001.90b | 18 |
| 1893 | 53.52 | 8.57 | '2016-07-18 15:49' | 53.5 | 9.95 | '2016-07-19 01:54' | BREMERHAVEN | HAMBURG | 381025786 | 2016-07-18 17:58:00+02:00 | 81 | 68 | 12.0 | 3.2 | 53.52 | 8.57 | 0.8 | 90.0 | 10.0 | HAMBURG | 71a.H7001.90b | 18 |